Hệ thống quản lý trường học bằng PHP / MySQLi
1 <?php
2 error_reporting(0);//turning off error reporting
3 include("connect.php");
4 ?>
5 <?php
6 SESSION_START();
7 ?>
8 <!DOCTYPE html>
9 <html>
10
11 <head>
12 <meta charset="utf-8">
13 <meta name="viewport" content="width=device-width, initial-scale=1.0">
14 <title>school management system</title>
15 <link rel="shortcut icon" href="assets/img/title.gif" type="image/x-icon">
16 <link rel="stylesheet" href="assets/css/bootstrap.min.css">
17 <link href="assets/css/loader.css" rel="stylesheet" />
18 <script src="assets/js/canvasjs.min.js"></script>
19 <!--*****jquery -3.2.1.js file supports the use of dropdown***-->
20 <script src="assets/js/jquery-3.2.1.js"></script>
21 </head>
22
23 <body >
24 <!--end of heading section-->
25 <ul class="nav navbar-right top-nav">
26 <div class="dropdown">
27 <button class="btn btn-primary dropdown-toggle" type="button" data-toggle="dropdown" >
28 <?php
29 //Check to see if the user is logged in.if not redirect user to the loging page.
30
31 if(isset($_SESSION['fname']))
32 {
33 echo "Current user: ".$_SESSION['fname']. " ".$_SESSION['lname']. " ";
34 $currentuser=$_SESSION['fname']. " ".$_SESSION['lname'];
35 }else{
36 echo "<script type='text/javascript'>
37 alert( 'You must Log in to use the system');
38 </script>";
39 echo "<script>
40 window.location = 'index.php'
41 </script>";
42 }
43 ?>
44 <span class="caret"></span></button>
45 <ul class="dropdown-menu">
46 <li><a href="manage_account.php"><i class="fa fa-users fa-lg"></i> View User</a></li>
47 <li><a href="register_form.php"><i class="fa fa-users fa-lg"></i> Add New User</a></li>
48 <li class="divider"></li>
49 <li><a href="session_logout.php"><i class="fa fa-fw fa-power-off"></i> Log Out</a></li>
50 </ul>
51 </div>
52 </ul>
53 <!--************************************************-->
54 <div style="
55 font-family:Nyala, Arial;
56 text-align: left;
57 background-color: #526F35;
58 padding: 20px;
59 color:white;
60 width: 100%;
61 height: 150px;">
62 <!--This codes to load the image loader-->
63 <div id="loading">
64 <img id="loading-image" src="assets/img/loader.gif" alt="Loading..." />
65 </div>
66 <!--this is the heading section-->
67 <h2>
68 <?php
69 $sql="SELECT * FROM companyinfo";
70 $result=mysqli_query($db,$sql) or die("error getting data");
71 $num_rows=mysqli_num_rows($result);
72 while($row=mysqli_fetch_array($result))
73 {
74 echo '<image style="height:82px; width:82px;" src="data:image;base64,'. $row['clogo'].' "> ';
75 $cname = $row['cname'];
76 $cemail = $row['cemail'];
77 $ccontact = $row['ccontact'];
78 $clocation = $row['clocation'];
79 }?>
80 <?php
81 echo $cname;
82 ?>
83
84 <div style="float:right; font-size:20px;text-align:right;">
85
86 <img src="assets/img/mail2.png">Email: <?php echo $cemail; ?><br>
87 <img src="assets/img/call1.png">Contact:<?php echo $ccontact; ?><br>
88 <img src="assets/img/location.png">Location: <?php echo $clocation; ?>
89
90 </div>
91 </h2>
92 </div>
93 <!--end of heading section-->
94 <div>
95 <ul class="nav nav-tabs">
96 <li ><a href="homepage.php" >Administration <img src="assets/img/details.png"></a></li>
97 <li ><a href="students.php" >Students <img src="assets/img/student48.png"></a></li>
98 <li ><a href="staff.php">Staff Member <img src="assets/img/staff48.png"></a></li>
99 <li ><a href="course.php" >Courses <img src="assets/img/course.png"></a></li>
100 <li ><a href="departments.php" >Departments <img src="assets/img/department.png"></a></li>
101 <li><a href="markstep1.php" >Exams <img src="assets/img/update.png"></a></li>
102 <li><a href="hostel.php" >Hostel <img src="assets/img/details.png"></a></li>
103 <li><a href="sms.php">SMS <img src="assets/img/details.png"></a></li>
104 <!--<li><a href="tab-8" role="tab" data-toggle="tab">Hostel <img src="assets/img/details.png"></a></li>
105 <li><a href="tab-7" role="tab" data-toggle="tab">Parents <img src="assets/img/details.png"></a></li>-->
106
107 </ul>
108 <div class="tab-content">
109 <div class="tab-pane active" role="tabpanel" id="tab-1">
110
111 <p>
112 <div class="table-responsive" >
113 <!--****************************************************************************-->
114 <div class="container" style="width:100%">
115
116 <ul class="nav nav-tabs">
117 <li class="active"><a href="expences.php">New Expence<img src="assets/img/new.png"> </a></li>
118 <li><a href="viewexpence.php">View captured expences<img src="assets/img/update2.png"> </a></li>
119 </ul>
120 <br>
121
122 </div>
123
124 <!--*************************************************************************************************************************-->
125 <div class="container-fluid">
126 <div class="row">
127 <div class="col-lg-6 col-lg-offset-3">
128 <div class="panel panel-primary">
129 <div class="panel-heading">Add new Expence</div>
130
131 <!-- /.panel-heading -->
132 <div class="panel-body">
133 <div class="table">
134
135
136 <form action="expences.php" method="POST" enctype="multipart/form-data">
137 <h4>Expence Details</h4>
138
139 <label>Date</label>
140 <input type="date" name="expence_date" class="form-control" value="<?php echo date('Y-m-d'); ?>">
141
142 <label>Description</label>
143 <input type="text" name="description" class="form-control">
144
145 </textarea>
146 <label>Amount</label>
147 <input type="number" name="expence_amount" class="form-control">
148 <label>Captured by</label>
149 <input type="text" name="captured_by" readonly class="form-control" value=<?php echo $currentuser; ?> ><br>
150
151 <input type="submit" name="register" value="Save Record" class="btn btn-success">
152
153 </form>
154 <!--****************************************************************************-->
155
156 <?php
157 $conn=mysqli_connect('localhost','root','','sms2')or die(mysqli_error("Connection error"));
158 if (isset($_POST['register'])){
159
160 $expence_date=$_POST['expence_date'];
161 $description=$_POST['description'];
162 $expence_amount=$_POST['expence_amount'];
163 $captured_by=$_POST['captured_by'];
164
165 mysqli_query($conn,"INSERT INTO expence(expence_date, description, expence_amount,captured_by) VALUES ('$expence_date','$description','$expence_amount','$captured_by')") or die(mysqli_error());
166
167
168 ?>
169 <?php
170 $query="SELECT * FROM expence";
171 $records2=mysqli_query($db,$query);
172 while($rec=mysqli_fetch_array($records2))
173 {
174 $id = $rec['expence_id'];
175 }?>
176
177 <script>
178
179 alert('Succsessfully Save.');
180 window.location = "expences.php?id=<?php echo $id;?>";
181 </script>
182 <?php }?>
183 <!--*******************************try add parent's details******************************************************-->
184 </div>
185 </div>
186 </div>
187 <!-- /.container-fluid -->
188 </div>
189 <!-- /#page-wrapper -->
190 </div>
191 </div>
192
193
194
195
196
197 <div div class="col-md-12" style="background-color:#526F35;bottom:0px; position:fixed;">
198 <p class="text-center text-danger" style="color:white;">@J. Muthama Tel: +254729734768</p>
199 </div>
200 <script src="assets/js/jquery.min.js"></script>
201 <script src="assets/bootstrap/js/bootstrap.min.js"></script>
202 <script src="assets/js/affix.js"></script>
203 <script src="assets/js/alert.js"></script>
204 <script src="assets/js/alert1.js"></script>
205 <script src="assets/js/bootstrap.js"></script>
206 <script src="assets/js/bootstrap.min.js"></script>
207 <script src="assets/js/bootstrap-datepicker.js"></script>
208 <script src="assets/js/bootstrap-wysihtml5.js"></script>
209 <script src="assets/js/button.js"></script>
210 <script src="assets/js/carousel.js"></script>
211 <script src="assets/js/chosen.jquery.min.js"></script>
212 <script src="assets/js/ckeditor.js"></script>
213 <script src="assets/js/collapse.js"></script>
214 <script src="assets/js/color.js"></script>
215 <script src="assets/js/dropdown.js"></script>
216 <script src="assets/js/DT_bootstrap.js"></script>
217 <script src="assets/js/dynamic.js"></script>
218 <script src="assets/js/ie-emulation-modes-warning.js"></script>
219 <script src="assets/js/jquery.dataTables.js"></script>
220 <script src="assets/js/jquery.dataTables.min.js"></script>
221 <script src="assets/js/jquery.dialog.js"></script>
222 <script src="assets/js/jquery.hoverdir.js"></script>
223 <script src="assets/js/jquery.jgrowl.js"></script>
224 <script src="assets/js/jquery.knob.js"></script>
225 <script src="assets/js/jquery.uniform.min.js"></script>
226 <script src="assets/js/jquery-1.8.3.min.js"></script>
227 <script src="assets/js/jquery-1.9.1.js"></script>
228 <script src="assets/js/jquery-1.9.1.min.js"></script>
229 <script src="assets/js/jquery-1.10.2.js"></script>
230 <script src="assets/js/jquery-1.11.0.js"></script>
231 <script src="assets/js/jquery-ui-1.9.2.custom.min.js"></script>
232 <script src="assets/js/jquery-ui-1.10.3.js"></script>
233 <script src="assets/js/modal.js"></script>
234 <script src="assets/js/modernizr-2.6.2-respond-1.1.0.min.js"></script>
235 <script src="assets/js/myjquery.js"></script>
236 <script src="assets/js/myjquery1.js"></script>
237 <script src="assets/js/npm.js"></script>
238 <script src="assets/js/popover.js"></script>
239 <script src="assets/js/profile.js"></script>
240 <script src="assets/js/raphael-min.js"></script>
241 <script src="assets/js/sb-admin-2.js"></script>
242 <script src="assets/js/scripts.js"></script>
243 <script src="assets/js/scrollspy.js"></script>
244 <script src="assets/js/tab.js"></script>
245 <script src="assets/js/tooltip.js"></script>
246 <script src="assets/js/transition.js"></script>
247 <script src="assets/js/wysihtml5-0.3.0.js"></script>
248 <script language="javascript" type="text/javascript">
249 $(window).load(function()
250 {
251 $('#loading').hide();
252 });
253 </script>
254 </body>
255
256 </html>